Importing Data
Importing numeric data into OmniGraphSketcher is pretty straightforward. In many cases, you can just select it from your spreadsheet, outline, or text document, copy it, and then paste it into a graph. If the data is in a text file, it can be comma-separated (CSV) or tab-delimited. Here are some tips for amicable importing.
OmniGraphSketcher makes its best guess at the meaning of the data you give it, based on these situations:
- One column of numbers: Each row becomes a point with the imported number as its y-value; incrementing integers (1, 2, 3…) are assigned for the x-values.
- Two columns of numbers: Each row becomes a point, with the first number as its x-value, and the second number as its y-value.
- More than two columns of numbers: Each row becomes several points, with the first number as their x-value, and the following numbers for their y-values. If your data consists of four columns (one column of x-values followed by three columns of y-values), OmniGraphSketcher makes it easy to create error bars that visualize the data as positive and negative offsets.
- A column of text: If there is only one number column, then the text column becomes labels on the x-axis. If there are two number columns, the text becomes labels on the points. If there are more than two number columns, the text is not used.
OmniGraphSketcher respects the number format you've specified in the Language & Text pane of System Preferences. If you have some data you'd like to use that isn't in your default format, you can temporarily change it in the preference pane for a seamless import. Once you've changed it, quit and reopen OmniGraphSketcher and add the data. When you're done, just change the format back.
Pitfalls:
- When importing, separators for numbers (for example, the comma in 123,456) should be avoided as there is no way to tell whether the separator is breaking up multiple numbers or simply improving the readability of one large number. If you run into trouble importing numbers in the thousands or greater, try removing the comma.
- OmniGraphSketcher doesn’t (yet) interpret dates. If you paste in data with labels that indicate uniform spans of time, like “January 2009, February 2009, March 2009…”, they are interpreted as text and applied to the x-values 1, 2, 3…. But if your date labels are not uniformly spaced, OmniGraphSketcher doesn’t try to space them out for you. To get around this, you could first convert your dates to integers (using, for example, the DATEDIF function in Apple Numbers to calculate a number of days).